Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_SCHEDULER_RUNNING_JOBS

`ALL_SCHEDULER_RUNNING_JOBS` displays information about the running Scheduler jobs accessible to the current user.

Related Views

- `DBA_SCHEDULER_RUNNING_JOBS` displays information about all running Scheduler jobs in the database.

- `USER_SCHEDULER_RUNNING_JOBS` displays information about the running Scheduler jobs owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the running Scheduler job
`JOB_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the running Scheduler job
`JOB_SUBNAME` | `VARCHAR2(30)` |  | Subname of the running Scheduler job
`SESSION_ID` | `NUMBER` |  | Identifier of the session running the Scheduler job
`SLAVE_PROCESS_ID` | `NUMBER` |  | Process number of the slave process running the Scheduler job
`SLAVE_OS_PROCESS_ID` | `VARCHAR2(12)` |  | Process number of the operating system slave process running the scheduler job
`RUNNING_INSTANCE` | `NUMBER` |  | Database instance number of the slave process running the Scheduler job
`RESOURCE_CONSUMER_GROUP` | `VARCHAR2(32)` |  | Resource consumer group of the session in which the Scheduler job is running
`ELAPSED_TIME` | `INTERVAL DAY(3) TO SECOND(2)` |  | Elapsed time since the Scheduler job was started
`CPU_USED` | `NUMBER` |  | Scheduler job CPU time consumed, if available

See Also: "DBA_SCHEDULER_RUNNING_JOBS" "USER_SCHEDULER_RUNNING_JOBS"